/**
 * 
 */
package de.alex.schulzeit.db.fixture;

/**
 * @author Alex Ruetz
 *
 */
public final class FixtureTable implements FixtureColumns {

	public static final String TABLE_NAME = FixtureTable.class.getSimpleName();
	
	public static final String SQL_CREATE = "CREATE TABLE " + TABLE_NAME + " (" +
			ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
			TIMETABLE_ID + " INTEGER NOT NULL, " +
			FIXTURE_TITLE + " TEXT NOT NULL, " +
			DUTY + " TEXT NOT NULL, " + 
			DEADLINE + " TEXT, " + 
			NOTES + " TEXT);";
	
	public static final String SQL_DROP = "DROP TABLE IF EXISTS " + TABLE_NAME;
	
	public static final String SQL_DUMMY1 = "INSERT INTO " + TABLE_NAME + " (" +
	TIMETABLE_ID + ", " + FIXTURE_TITLE + ", " + DUTY + ", " + 
	DEADLINE + ", " + NOTES + ") VALUES ('1', 'Schularbeit', 'Lernen für SA', '23.11.2010 13:00:00', '');";

	public static final String SQL_DUMMY2 = "INSERT INTO " + TABLE_NAME + " (" +
	TIMETABLE_ID + ", " + FIXTURE_TITLE + ", " + DUTY + ", " + 
	DEADLINE + ", " + NOTES + ") VALUES ('1', 'TEST', 'STOFF XY', '23.11.2010 13:00:00', '');";
	
}
